import xlrd

data = xlrd.open_workbook('菏泽全市高二期末考试等级赋分表.xls')
table = data.sheet_by_name('所有考生基本成绩信息')

Name = 1
Class = 2
School = 3

Chinese = 4
Math = 6
English = 8
Physics = 10
Chem = 14
Biology = 18
History = 26
Geog = 30
Score = 34
newScore = 36

def getCell(x,y):
    return table.cell(x, y).value

def writeFile(filePath, content):
    print('Write info to file:Start...')
    # 将文件内容写到文件中
    with open(filePath, 'a', encoding='utf-8') as f:
        f.write(content)
        print('Write info to file:end...')

def readFile(filepath):
    f=open(filepath,'r')
    return f.read()